SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412078 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412078 [ RunTime:0.003669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012121,555480,243157,263898,636688,219109,126388,103224,797893,429760,321691,329667,938951,240859,230097,118625,240870,295124,157034,824325,943208,123241,552949,655939,300717,311313,329148,889305,812460,514046,103238,365152,557948,70813,145244,714727,3504,442542,395350,1004591,699812,692096,82404,287625,860272,404547,755159,167042,279208,4201,1041451,66202,665127,91787,287928,104087,191498,457212,39245,400064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]