SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563301 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563301 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (869549,169904,629059,453917,586684,803578,685911,323455,360759,711159,415552,625383,765600,583152,468218,360465,18214,325332,145469,252963,958325,518490,598035,750193,943294,1032116,792426,433739,908786,682599,460462,460739,700560,59215,951086,917354,944223,482041,671413,735280,560856,210572,483898,560803,587149,190534,433488,971894,922982,704534,1640,799616,339283,561657,477673,1046032,866310,766759,965244,1009017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]