SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444445 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444445 [ RunTime:0.001946s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (688405,489676,304574,364103,772145,415559,468612,398332,1033615,1048008,944284,367981,202703,516663,713455,352107,588455,525290,104240,949348,205951,58134,33083,512299,344085,814727,1021590,59346,257419,605081,63675,369944,366563,38771,842314,379054,650323,186823,86164,836343,104886,248488,539115,285764,797779,926450,709161,6497,461481,352167,606982,575130,585459,837945,797735,825392,409415,247086,177034,426898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]