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` = 301882 LIMIT 1 [ RunTime:0.000562s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301882 [ RunTime:0.002716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362575,318785,46233,747112,606962,739080,487025,1042245,722503,45850,134358,757163,1030833,698728,436629,801889,214142,652276,337080,329213,706000,608160,212136,437128,46322,285191,503165,662807,871037,236576,29720,702014,108386,1022385,607987,610291,735747,513794,616526,649848,676894,808725,864313,1005950,98680,376934,879315,773763,857685,970437,221599,534255,841422,135597,178959,298367,309770,1012028,308898,724889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301882 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301882 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]