SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 339281 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 339281 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816449,389532,328951,278926,805123,1028789,130235,799770,26040,739431,477905,386670,658263,529723,818143,615113,519182,847767,175389,1000539,84295,971312,500213,59009,797449,35403,666172,521018,780708,624328,331445,151238,411014,245054,603136,669907,338348,98028,1026574,189489,898547,205905,159810,548174,14251,493627,805938,513315,958876,976158,60679,648592,223568,730438,943703,316211,978497,625360,54345,192849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 339281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 339281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]