SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840318 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840318 [ RunTime:0.002154s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654542,165623,695435,757407,483050,410684,243211,663892,706259,1007605,476695,296781,387972,466991,959148,538181,587495,567547,959731,127694,1009400,426138,781032,496189,236054,696282,283224,516789,867790,146084,671965,608091,82511,501518,752370,1001566,718286,365839,551727,137410,243044,788299,13084,656428,450885,411438,717484,1048639,522155,18395,740546,992182,568650,458086,326959,627645,699477,593492,1010412,451407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]