SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002490s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553821 LIMIT 1 [ RunTime:0.000935s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553821 [ RunTime:0.002297s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280729,395584,859096,993327,574840,591301,64471,506591,52446,968095,888106,109689,1006740,14967,446517,954064,118576,749880,364450,298767,423184,139897,342312,918816,85987,677175,557596,14712,647121,983203,895462,397043,938091,271668,342780,692405,498489,817645,752027,186044,846533,45620,399101,937130,717682,992888,681649,737667,890450,552418,289427,422917,920596,672467,1018534,187178,368583,874751,41216,32647) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000974s ]