SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430978 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430978 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444942,337689,401904,443901,1002227,394681,116158,595251,648671,862848,935305,851797,40028,347356,684900,552690,93436,833102,1010459,539998,660980,503556,155349,1012825,364164,401036,541481,937100,914774,1039421,970690,842613,557204,483709,1045482,239534,989557,627490,674739,116071,986504,330534,530081,79573,252352,402263,501945,793230,672117,396747,66099,275018,266055,461326,399766,945377,624925,695143,116196,308694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003627s ]