SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59283 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59283 [ RunTime:0.001984s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008107,301949,525130,1030670,358864,1042551,587176,1004779,990254,845322,205254,421324,933814,755094,614488,1010192,1031035,144486,353509,958457,851634,73866,752392,753441,1020665,780528,400621,514038,624651,557173,989047,389711,848945,18642,748386,163787,397114,87741,163791,876441,859598,367923,798665,812096,839294,968044,500172,470247,1004003,652380,367011,930974,83641,50705,771720,159975,309288,208073,299163,664157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]