SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473709 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473709 [ RunTime:0.002055s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (634980,925001,156927,807751,1016718,831727,565993,669837,424846,493081,718392,967984,365158,117133,687544,878601,15008,270231,756610,800624,77631,569758,433588,180977,200057,936538,163959,811309,818737,438623,120340,158096,14854,1024514,627758,697957,39554,944074,400937,163429,675136,946905,116080,871480,807175,269293,943270,90308,859011,322661,789929,338548,765688,139435,19747,578724,549462,840038,135250,570550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473709 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473709 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]