SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000894s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 389540 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 389540 [ RunTime:0.002421s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010456,143480,626742,685704,903268,383210,476019,640113,1040461,936891,1044869,366286,757357,14300,455605,82652,461928,6600,21835,232770,303295,371864,929054,63125,345232,648745,721891,180172,763908,923786,26454,522297,1021343,447260,36584,954491,432977,998561,1038967,734415,607973,539949,603314,338393,25609,991078,742341,532847,546711,474429,299029,930582,350404,199125,305914,792469,838952,599490,891574,8513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 389540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 389540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]