SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527982 LIMIT 1 [ RunTime:0.001157s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527982 [ RunTime:0.003100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107090,722785,74625,965591,28187,841469,751071,444744,671673,972967,633411,725502,407813,601014,318553,488288,672428,658700,563895,80375,587717,884141,814088,906541,144188,483924,927846,954683,982127,7495,159634,233155,798463,334183,672889,473529,213549,418997,953838,491224,480087,98525,13067,327358,457965,211294,239047,948111,269175,416408,589863,578383,426948,204816,928371,363595,900243,83306,357841,224487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005915s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527982 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527982 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000738s ]