SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020698 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020698 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771133,423053,707580,471990,289712,410816,739468,110955,765451,498321,477257,1035714,977865,595565,1034333,766255,405208,253814,464951,512954,732223,237942,197871,339257,897690,305280,771398,1033695,834116,874537,418215,900077,588375,183618,307117,481743,752225,447935,927830,108016,813808,454160,350041,135362,1011734,772804,769005,203763,925713,149887,250583,711371,177177,518852,320389,331128,493949,256389,216419,771145) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]