SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 239818 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 239818 [ RunTime:0.002318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402749,527291,940985,134916,809000,171094,48798,586902,623651,369115,411855,6185,806881,709438,1002118,711786,693819,254843,476410,554070,728437,19483,445884,720142,656009,636594,344740,306164,794843,341714,843840,164841,798849,389594,108136,607237,762153,33501,624708,202772,885271,463186,922493,268353,677385,113277,545889,777136,820534,442969,545394,579987,1041064,830212,122303,908775,878348,1021495,450662,256127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 239818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 239818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]