SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421092 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421092 [ RunTime:0.003040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (817999,164060,478593,104624,551658,183034,163589,19681,752454,31684,48778,1008383,602617,948419,931347,98812,268891,210059,764898,738377,475194,287040,623906,807804,619033,677181,448327,514295,393109,1039269,348398,266335,505169,549847,410483,124389,159044,1026862,450007,188761,812416,36915,281435,812475,856358,275140,738497,416787,978047,921851,53204,950060,318139,724155,106019,872226,410736,61995,387815,543761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]