SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003970s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408344 LIMIT 1 [ RunTime:0.004451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408344 [ RunTime:0.002222s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013133,441001,445782,1027458,968771,716234,326899,1045846,743573,452365,818679,878239,420604,348247,687035,584683,455754,900334,89312,783075,211814,962496,1041983,581710,875191,1022723,684092,1045509,449032,878877,1033512,682246,648844,374253,10118,230179,352883,1023921,940153,174133,367454,795495,720900,1026555,638295,383434,333035,843576,452426,804650,730692,960768,117744,969848,772245,669496,411156,405674,158562,400250) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408344 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408344 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]