SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351027 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351027 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (27249,157192,242019,201320,346198,554155,152681,435576,908471,157519,31570,878224,744412,58476,782947,497135,912223,972683,737524,460671,667858,133279,352409,687950,743509,548846,264651,190338,100084,11951,491563,730844,655909,69411,582406,771161,101739,2623,39885,602548,1047181,117686,74350,401154,463876,292214,940295,787450,789345,785601,1007431,657799,136234,930280,880451,995188,147932,771785,1041605,610533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]