SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001694s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317840 LIMIT 1 [ RunTime:0.000780s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317840 [ RunTime:0.002767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (635456,331223,1017960,781827,408001,863567,316848,963624,70894,675831,363281,768041,936076,911215,887532,560751,749756,197194,873203,224278,136007,165708,65587,388353,1036594,630178,799984,94174,614941,935220,790397,237359,436,747382,623036,1020746,572476,642983,162374,668242,458244,573542,83166,323351,79546,33851,831050,953149,825865,315863,355268,57090,807354,280620,726093,206800,26341,446171,452544,540986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001236s ]