SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283283 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283283 [ RunTime:0.002510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620166,763611,714350,106069,841774,310560,432811,378183,246428,335646,264016,4464,506226,869392,156229,110082,968089,198886,271945,669468,766797,990244,446982,665402,574402,58227,932112,90414,805076,829817,805232,237060,719629,1048759,142151,398977,804700,411939,144200,889282,876766,345804,95908,636157,535577,668605,110479,326035,251185,1005170,997346,163987,412423,535173,24253,572336,365227,281515,514171,606077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003751s ]