SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49765 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49765 [ RunTime:0.003895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419048,203746,786351,791948,798375,153568,37287,766631,901958,94455,565192,704334,146222,354766,178628,311807,1025153,464222,873611,1002634,331118,902229,996016,32554,265719,651118,274172,167227,339368,574207,831889,586098,381842,414968,661623,693741,129887,32346,967292,588097,746958,845780,461354,320965,691236,847599,304582,736812,509121,306809,137787,719078,751409,517587,376156,448427,230913,1018013,898962,950662) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49765 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49765 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]