SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416506 LIMIT 1 [ RunTime:0.000786s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416506 [ RunTime:0.004856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953269,455038,1002657,527146,69890,305662,766892,642009,224987,256616,287369,506506,369120,316624,66138,358053,789222,915998,972726,18444,684741,877005,88099,871845,810117,833490,303512,432895,371885,517978,45649,452853,812655,382893,1001421,236831,391447,1002778,13070,852308,671393,942203,955830,124876,420954,919769,67474,850543,939979,464613,86866,781199,448531,640076,1026765,427968,599968,59051,836185,982553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002807s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000767s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]