SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028506 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028506 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810949,332581,735144,625055,315765,36510,879365,690602,434948,183238,641532,667075,856885,54017,1017045,635160,831652,523142,998513,975287,659842,923720,507506,1031111,273479,919231,700345,190587,962085,666725,1005382,497603,7041,364474,228772,297312,622317,108182,499368,17549,912997,996554,196113,997445,240419,178798,767735,964775,137878,348830,999363,634198,85885,18591,786227,896324,777638,491013,9824,502789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]