SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001714s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354321 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354321 [ RunTime:0.003492s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123326,666121,423916,433118,267169,163371,821420,616717,596059,71951,750638,971846,92862,458450,958796,45481,299829,390179,494159,718123,1043013,845174,423074,521311,70044,278798,233406,664742,840286,799960,341077,617337,800231,446487,666345,499903,439236,856050,930246,261684,691773,677599,807534,379151,106284,997944,92365,193864,873697,793653,459548,341412,172809,641877,517646,520201,566307,921106,719066,904024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000871s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002317s ]