SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527081 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527081 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032286,375955,284100,922148,644048,841189,492710,925086,800998,568926,10781,934261,172188,266136,414099,922239,398834,713809,63819,1026002,872435,741015,459698,220757,900007,662348,903540,535388,778601,444948,468789,759506,390040,109399,678461,138333,883363,600228,966673,399349,454717,49666,320405,468155,937095,27350,549285,129286,7195,615389,585334,542398,480612,687742,28800,501202,462592,158225,522538,928808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]