SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414507 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414507 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (33950,163586,495044,558034,855891,651995,411000,56037,171671,241170,729053,973461,456680,526808,615728,866648,76651,36016,81135,294304,941253,1031713,476570,720177,642879,92371,843010,288530,349775,70454,454549,523143,713809,539793,384523,513836,74877,27064,795801,1039111,832761,324997,281469,1008552,1244,942182,362942,226157,383378,821892,147840,501423,1036316,625540,215296,275002,368999,998350,202865,391335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414507 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414507 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001225s ]