SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001648s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004280 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004280 [ RunTime:0.003589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107787,725208,586742,995248,641895,542337,244120,696421,1009455,185632,237932,262037,822365,730790,484297,18299,789633,1015506,61663,304238,126742,775601,415371,40765,899768,155116,395396,373548,378827,655837,458184,769887,610759,762529,589948,109903,284020,939542,460733,188723,114967,164381,582441,909519,1041168,726871,811964,538826,419078,92838,628864,411783,243937,332014,775716,557172,177210,529859,851287,896271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000397s ]