SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109286 LIMIT 1 [ RunTime:0.001017s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109286 [ RunTime:0.002423s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122797,569050,52972,250855,374655,750420,482011,281188,797971,768070,543780,173593,138236,989823,1039792,348018,842987,408081,326636,542231,407787,627079,686965,834914,312946,222097,882768,774579,393912,799449,226245,237546,315108,295012,898368,900707,362457,1023079,860819,211786,340637,102572,962522,364837,184892,182103,921300,713306,956942,497964,83099,453676,65921,128337,782284,596437,441839,1040305,145499,142671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018805s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109286 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109286 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002024s ]