SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285940 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285940 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530576,120490,325554,33994,539985,591540,992272,565132,786743,333954,397162,498139,200219,553749,459144,701417,1022211,382152,74697,308760,957683,916556,433890,488135,480687,719712,945965,221309,945177,789790,350298,588097,625159,466832,480843,335210,469026,992399,786727,470595,34841,266638,336612,773091,682379,202617,201941,708966,949776,924463,944695,420358,349403,848660,948122,557721,867704,759327,503813,654027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001792s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]