SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47139 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47139 [ RunTime:0.001754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (67335,882067,836039,290254,1020148,94220,441162,278287,400664,793771,1041503,534020,578831,599912,336049,999348,451806,107801,736792,748677,559828,661037,1011487,756173,696101,494843,143000,615990,313892,1038904,113526,394232,362163,160231,883625,506642,451999,768365,235664,73730,209284,851050,250892,991299,741479,492258,862029,271302,429870,1012313,360677,554439,771806,356247,328718,359635,564711,872394,539261,978925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47139 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47139 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]