SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405458 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405458 [ RunTime:0.001484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820246,538292,164645,692695,403168,389572,553379,816118,344486,493603,83000,1019993,860983,549043,800876,119057,580829,1044716,218193,826056,945074,54574,101389,740927,34410,58996,1010663,448483,658135,512288,222606,833190,840163,919175,998096,54106,631899,905452,327638,149126,611496,169298,1043035,757403,222026,493495,405956,827062,439185,386600,33787,576669,597099,840892,359773,597910,473401,119233,781938,404865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]