SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319320 LIMIT 1 [ RunTime:0.000591s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319320 [ RunTime:0.002167s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011485,913043,229335,489463,159548,420316,579752,464259,1003748,375979,550904,559383,550926,455468,1016171,656878,610637,466225,462980,866158,1000173,397602,706847,157301,660709,94015,173191,383235,910770,233944,932255,381437,140675,567924,916845,317241,718456,713430,880671,760987,266667,375057,579676,631165,620269,561234,693467,608809,477804,670612,525935,111767,94087,580581,692805,86265,102224,200770,680412,268011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]