SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567306 LIMIT 1 [ RunTime:0.000954s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567306 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588272,79200,127731,179513,610476,867083,934943,711159,275996,807524,668095,274512,938855,125944,1024084,915824,817834,866398,135181,779217,716627,1037816,279723,61155,898701,655659,150670,335537,676395,473260,1007269,954492,211106,343105,503138,850787,241406,52246,1000511,733405,148874,608794,38487,380823,31032,1037074,353759,49787,994269,90260,823973,374461,78196,939167,295581,709163,782510,435465,59863,1034434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006679s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]