SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920059 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920059 [ RunTime:0.001559s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546058,996298,191933,276643,18936,533418,524193,372902,402928,770390,44525,603713,670361,1000544,936760,125842,196510,473495,471416,601930,25138,593203,912816,731886,106282,69490,903081,749354,1003814,686104,106727,68277,90874,828996,222546,753458,904472,782565,13568,639958,692992,45462,873045,66374,936519,279008,78191,625448,907343,821276,671694,761559,505596,904210,162297,1041447,30670,385641,987912,368894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920059 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920059 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]