SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490028 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490028 [ RunTime:0.002090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672069,998096,898588,491792,447045,778249,158122,102917,950616,1031915,245489,632616,578109,404542,299554,163104,30555,830542,742284,1020392,96554,295832,1045459,66200,317482,997025,954299,548478,365893,5533,514316,988902,610744,620986,751405,219119,261097,420213,333258,459092,815569,751866,1017691,852360,561126,824784,161155,434299,96623,472818,652161,510142,729766,22303,27434,964274,428453,535466,437386,547822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000810s ]