SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501757 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501757 [ RunTime:0.001902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369418,1016303,720419,344784,619366,894940,22042,162351,742904,654095,817296,118368,368512,248719,179337,517271,320930,542941,502280,673815,958996,38278,101528,705296,259835,273686,620175,923631,745712,667410,96343,607052,183343,1614,29393,261405,44688,407903,318236,516222,225970,545259,550822,102113,339183,207548,608448,533670,775389,827405,16514,932620,629155,477478,414232,1036563,353234,941639,144795,140515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501757 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501757 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]