SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014067 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014067 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (784687,527595,331384,175737,500869,22311,804609,205470,400525,214709,268601,356326,995401,548567,302247,373401,26470,226936,723581,200856,2760,4841,428257,766406,123713,41592,237401,728572,346182,545512,322837,989739,226873,101076,997818,133075,721413,211217,468564,42318,966983,6526,730296,90104,9197,423798,34006,768782,179797,343846,41378,481686,405755,964549,958327,130173,355867,119894,662360,914540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014067 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014067 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]