SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 226754 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 226754 [ RunTime:0.004044s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414373,371610,382345,53764,1002348,1018333,447887,724268,88191,891596,625865,1014890,976232,225648,250359,973702,1012214,279121,1032993,1009629,149690,499061,996943,1048367,696212,410370,877664,392021,52813,940342,335382,510655,785111,74043,564152,266591,547974,412798,572145,162897,372063,27789,777718,374603,163867,1897,288612,402172,487340,803923,462516,194705,468739,269061,453244,12773,77553,416616,992170,218440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 226754 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 226754 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]