SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490583 LIMIT 1 [ RunTime:0.000558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490583 [ RunTime:0.001888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (782017,305280,286249,522192,1023410,505862,473034,665756,630838,384071,112186,784011,546224,246260,225735,331538,804088,723582,297282,894355,201570,65144,103521,1016254,884064,501910,758781,115790,200386,857368,576104,348814,1011024,203349,816075,99879,432741,1033170,471709,918968,948427,258952,139550,977359,966320,342547,314434,274557,647225,20502,820973,710251,126739,134882,789011,953683,628990,839473,326491,541238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]