SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004203 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004203 [ RunTime:0.003641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115940,505626,723660,31205,856002,490441,876004,765299,429937,774972,1013903,82873,856733,558253,914357,131278,794705,433085,92224,279943,498048,638282,157518,248389,522417,584581,942393,969134,8611,773321,710922,468761,1027178,233405,356849,380141,594749,1028484,500833,845600,950449,397983,639959,765082,201881,964865,241741,906265,726374,230470,592833,202860,720268,156089,125169,1001450,966962,327514,1039013,967387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]