SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033902 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033902 [ RunTime:0.002488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (878432,287820,316539,271450,922593,169655,1036386,28825,901833,389206,229832,638279,897432,762491,704866,790961,313655,510477,906323,342511,516058,8752,847396,115934,915272,737615,431173,356014,73584,581802,854089,423740,398634,621021,291967,962169,491266,218792,201426,916020,125996,745039,346765,569255,15809,894075,651665,999227,827797,803354,907888,107478,696250,51071,203374,507412,873209,295322,107140,283065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033902 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033902 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001878s ]