SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 253674 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 253674 [ RunTime:0.004464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42448,459047,394125,621018,363324,971442,21119,629778,643117,706959,462145,900661,104723,403072,716235,983740,719365,526406,78408,465023,59351,523542,125234,920570,430700,487883,383573,788007,482001,763423,65504,580986,443726,869102,758225,250671,1009878,430710,857186,728050,239694,987853,645996,790866,100707,1041315,459258,530466,376495,157047,168586,140309,865981,289652,716029,810499,396407,193719,1015347,831438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 253674 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 253674 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]