SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002913s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 673572 LIMIT 1 [ RunTime:0.001791s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 673572 [ RunTime:0.002264s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546196,231218,399355,203336,245795,364226,641856,1012046,630886,201756,912242,401709,242577,976965,31345,843327,695794,78771,384656,984022,608112,728240,278373,701080,270441,221236,265181,882223,423120,5986,823611,781939,318875,151728,318767,133685,1039486,1016613,39630,61444,401214,340265,902442,949580,137943,323163,1025933,693773,228426,854994,959885,778734,562615,833075,67878,145161,174980,248868,951585,90089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.025548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 673572 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 673572 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003403s ]