SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 913810 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 913810 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (979866,489118,106182,440867,9986,296929,201164,1046410,582027,493121,161844,710171,44650,186238,665990,370648,619927,80930,91314,574204,102914,309179,593282,77493,79901,365607,22164,269196,454871,115537,136437,1041498,30349,229195,127331,702534,912012,227593,22357,730515,160557,375767,248548,742972,756019,37232,886158,12494,372347,631360,1029479,68488,494124,72872,990262,185793,986654,540945,814177,909509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 913810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 913810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]