SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108329 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108329 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108678,793280,314383,817259,674231,517785,385040,797974,551062,487464,189725,910968,981591,84176,700774,433606,759368,494714,905435,669018,831324,343301,127561,77297,1026340,76604,831887,555994,449987,877322,912712,328221,522815,318624,782196,181078,846640,155174,718363,108901,207579,100824,356489,259993,122786,755975,854133,531153,305112,100422,552617,655525,315911,772059,512144,919281,244583,446171,864273,876267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108329 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108329 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]