SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482097 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482097 [ RunTime:0.003391s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005687,452413,728601,484737,440121,927739,547841,806168,818676,1016912,997469,670639,540420,856161,912663,1022214,519090,441406,481073,354805,664133,90090,88705,101374,727288,37451,556544,525643,669942,431064,271125,785981,332900,667195,987336,736929,399393,366887,1046403,293914,786865,432364,163503,555710,82553,432440,542209,676727,4037,496348,95988,170901,112092,916815,1022685,515282,713786,608099,889660,353201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]