SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 387208 LIMIT 1 [ RunTime:0.002087s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387208 [ RunTime:0.003748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800160,215921,828608,101049,956226,932114,438669,814027,907793,849482,353970,336191,248349,13839,507453,133831,305861,427962,859106,388332,39717,763552,585173,400296,524650,504245,598822,851498,248375,650750,1000347,853331,972428,495242,965297,1047937,1031777,56910,1015640,168480,173802,874305,961545,834408,447507,6678,820143,762638,277886,358526,4889,509158,735390,378144,1039886,579297,562755,108550,516925,989321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]