SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803301 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803301 [ RunTime:0.002133s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026114,762460,286898,822923,464270,220459,111729,90089,58709,718522,446009,305906,633424,146155,536977,100866,723919,675473,955489,1008687,809142,843754,348352,239419,263351,363906,598698,592848,384823,357804,641046,111918,460996,546516,367362,118800,1001197,145203,602248,661592,890220,307834,41752,758558,424373,565532,64087,71835,634274,354511,377159,132772,339802,520100,610445,673679,787068,484161,267912,972625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]