SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108399 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108399 [ RunTime:0.003127s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (782710,914740,763899,224007,375448,279411,686447,850944,798213,74443,479178,774227,122504,1035336,703892,807485,716620,103460,334626,414229,968972,1028624,500679,657770,883302,887383,544635,1025945,383166,918149,427470,629360,368875,489436,912220,56105,311158,667809,753872,347193,727534,382882,546206,465333,96724,555370,285898,489520,550639,152395,987404,430864,905722,194865,788072,256444,658525,432176,371459,898960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]