SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 644245 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 644245 [ RunTime:0.002037s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012553,871214,6704,469032,231256,297383,605931,386073,1016023,404938,1020306,238109,483903,715272,461878,724508,824508,451215,753259,894291,492585,417830,1016128,317385,555271,701688,711794,466860,964068,397774,510146,823121,274608,818961,922741,632364,541317,49203,817952,25192,913981,1030208,473971,271267,173761,1011400,268137,588081,637056,659493,592330,648659,307144,493043,249922,106416,724312,569596,968313,245388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 644245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 644245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]