SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50142 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50142 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102245,627576,755792,391093,476190,579168,152414,930962,565960,733430,185976,364878,677004,610818,325277,824849,516515,613560,683853,709711,633589,187508,251612,270164,705164,464215,595242,992035,471312,147998,554892,445341,843917,299811,363650,584303,513823,940959,805085,404474,893359,16809,478119,762273,729652,737361,979497,539115,333728,845358,148631,293663,973906,897656,819418,817789,119165,245965,306561,499539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]