SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515420 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515420 [ RunTime:0.002076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518823,372089,934378,14808,415711,525525,51144,434497,852288,819970,497874,491264,460642,804201,783305,785329,757875,115189,322370,759190,742283,486456,574028,943748,154153,648729,603126,416689,466051,935721,483905,910205,597566,649025,1034203,1037360,499481,1018301,430016,912389,61524,809325,573440,809000,582129,20308,900339,10709,793659,777768,762921,459614,485722,414691,816517,1004547,854044,107270,847970,207362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]