SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001497s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563239 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563239 [ RunTime:0.001983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844959,710329,294474,400807,70467,886270,382920,501137,876024,1008455,203899,480522,731030,976050,311676,637508,514654,223146,878319,540973,49284,386459,163686,943237,171535,613580,841265,245215,4235,53760,380538,891054,107979,405069,432011,493557,478852,657478,154741,80498,565109,847031,716709,951211,79177,2518,133190,222540,828967,732204,272169,933075,981672,920597,626842,653946,1040656,169285,299389,103069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563239 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563239 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]