SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 991013 LIMIT 1 [ RunTime:0.001640s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 991013 [ RunTime:0.004294s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (973715,592865,438846,812572,645618,917001,1032401,201703,149711,900458,261441,314497,836512,593689,296377,86593,662448,540353,50172,1041773,245128,766209,748972,362219,1044447,787341,95622,1025570,740657,804780,143464,88428,358806,269116,620506,868440,116342,995859,1019269,471360,211186,151800,600493,250216,113961,880816,735210,599599,888628,75229,41857,415805,870496,344918,202468,873547,867390,47431,73341,588974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 991013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000656s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 991013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]