SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001822s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535717 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535717 [ RunTime:0.003618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009054,704535,430660,917467,47672,243516,271957,318586,268810,546148,43311,767142,474444,746107,489372,97559,98007,104055,442806,299116,81742,869369,898275,39206,681242,457999,78209,186747,537792,873298,361764,693336,898962,76171,760820,543927,91497,228078,788380,411,897000,973371,396549,414406,999096,290964,262408,576643,54660,115460,588480,361914,143485,104217,755446,494348,487475,295169,226699,13478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535717 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535717 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]