SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017423 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017423 [ RunTime:0.001498s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204851,1007037,25250,729796,732905,701211,341473,619419,288324,360441,520613,601021,1008964,970666,193278,122806,401981,174251,764009,120032,753253,281960,402174,914578,82088,626626,830301,17438,496455,275023,71814,346925,402804,262613,638149,691823,16680,477136,587600,777731,426589,27770,715061,540086,859882,600380,648259,801618,720949,435442,804475,361941,748216,741465,41517,212657,30801,426188,601092,457771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]