SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 989218 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 989218 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109253,432085,277394,400169,581064,902666,12105,353662,711572,281143,538120,402862,548076,707281,955015,78000,716964,630653,582365,262484,196972,812022,540143,1021175,504106,161088,724660,676707,637449,955866,1000997,184693,483430,193950,723155,614884,317094,552887,766575,313147,384206,462589,757198,893206,626646,283872,10163,1039879,796410,594601,860403,684336,924777,155308,427734,816845,969905,916320,541500,309999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 989218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 989218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]