SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420616 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420616 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598098,91283,225309,19445,522813,778584,839911,535251,205256,514698,368990,776399,431915,420286,614896,972232,168443,615705,856480,338655,423926,914156,293926,958620,997353,351274,202309,856225,745462,525461,932908,937167,771590,776701,398578,638675,399244,92759,129002,889607,767855,647030,404465,801696,521007,889341,847710,307420,790688,645524,629119,899724,94570,374183,624084,678001,395478,236835,721488,491154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]