SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 383328 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 383328 [ RunTime:0.002079s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (67791,668426,621219,688000,978733,182599,467523,141108,163451,213214,154546,774101,589265,381913,933481,312154,549022,79868,363811,443326,504744,262950,691995,201037,191241,917751,55024,671489,607183,655673,427209,318698,619101,613773,35283,750846,318335,716073,894554,44792,188376,624899,1004540,353000,243665,50296,906887,538817,358995,142086,518164,84614,88008,1002153,286199,385572,728599,478402,1013762,53851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 383328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 383328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]