SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541381 LIMIT 1 [ RunTime:0.001136s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541381 [ RunTime:0.002310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83805,452141,270094,477121,565890,921398,181162,897877,25957,110029,639687,573442,851627,160239,91606,549460,794237,317507,849946,686783,336948,860689,449301,1036527,305682,404534,810013,50711,693986,348268,703599,828449,672483,583996,983545,510586,921980,152868,716640,271427,370898,882444,221820,1004495,532953,398420,1039271,287308,317795,692613,1006574,806517,480846,579963,160032,399851,694475,292107,745480,299417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]