SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426568 LIMIT 1 [ RunTime:0.000764s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426568 [ RunTime:0.002670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310449,798450,91361,361709,949738,99224,760948,73092,663233,230414,348030,24566,973144,760069,704262,644801,875732,567261,192282,113313,556319,210307,802627,151073,850912,488017,89265,101961,145562,789472,215147,805256,266955,335521,213709,112448,853526,201506,701241,144295,190411,103019,27929,411843,220997,316867,861225,237777,459809,704885,898535,67496,908805,447709,715407,481742,157626,898392,37172,714637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002645s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]