SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537541 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537541 [ RunTime:0.002353s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478326,705995,886928,980218,425064,769568,946850,792973,728344,810536,452893,7126,79577,800322,158168,463252,943574,663192,401633,924901,484739,859088,667068,1000794,487643,1036981,113449,1016431,149959,462300,196912,30505,887818,743749,427366,271932,490623,829639,73748,297882,285344,957443,236687,205542,103105,432341,26143,471385,564923,342550,402092,390471,120629,278891,935620,247413,255273,524666,450551,716014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]