SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102623 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102623 [ RunTime:0.003157s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (831484,397737,515111,870027,97670,443647,479944,1006175,238187,379100,834475,238075,684099,285923,855750,726965,975752,558389,283506,514439,341996,248288,423585,859772,855083,566149,634188,967344,790480,1010181,192149,501657,545522,601604,972374,42594,414607,724940,325259,828244,1177,448027,1005863,196505,469484,644317,966539,1046215,461777,784780,918319,626753,60441,548181,227368,528849,730042,683232,773202,368553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]