SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26974 LIMIT 1 [ RunTime:0.002022s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26974 [ RunTime:0.004921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261445,563947,89998,468260,121749,1018240,402357,254185,856142,903003,781991,402574,264749,761001,85812,717874,1011290,541106,946295,217360,49862,123010,590798,332155,729206,46498,369646,862321,691196,662725,230604,35558,778849,944240,993031,316182,58738,142909,833612,519293,730088,741150,816688,551063,632158,521970,992812,238750,226894,57439,460850,311981,830298,447998,284446,50806,673429,657633,988665,744331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000899s ]