SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504346 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504346 [ RunTime:0.001962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161125,723913,1043595,660032,447204,612803,726611,183478,430257,919100,340831,836341,359010,47407,488400,905144,327970,110423,184002,879595,723176,747258,176901,681665,380238,68796,872403,144859,304539,504100,728803,283821,434882,1000324,543549,60702,323645,10850,234946,12272,467876,51479,137285,688888,950096,177020,240013,302004,47064,348195,151109,917531,536540,684752,213886,357475,610728,187579,763748,1035443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]