SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40038 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40038 [ RunTime:0.003018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97393,80916,783815,201355,982557,383058,672613,348605,1037656,817817,737529,323982,164881,756321,820620,1032199,416265,832576,951869,170480,675559,25480,1044211,752514,252429,1023810,724421,982895,191310,420355,1001862,405349,653051,262665,207506,346975,911829,224522,374954,339749,873611,499350,177211,817007,700363,717029,540049,715784,396822,748560,165191,98608,1036099,421260,246554,656489,240743,986958,407086,488012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001764s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002548s ]