SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432334 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432334 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185548,262023,164918,10246,545934,843928,343136,210333,437521,551601,400548,857413,199203,201385,424282,153361,646903,306761,939439,422352,3828,841592,516303,200527,661665,588160,265753,534831,225287,660880,195367,133485,823403,845194,144103,595173,26780,428615,822797,962523,30951,806102,882454,1035651,939259,319019,368206,826109,142575,205169,168494,967753,1017793,123424,1016141,103890,977457,574538,271905,108475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432334 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432334 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]