SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001543s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405411 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405411 [ RunTime:0.001896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243220,539474,516019,583492,191060,25546,434869,680143,47476,152145,532467,917923,56419,842416,302437,140032,241445,98652,282617,853480,875218,384552,367655,523160,674645,910416,185353,485461,14972,833937,944909,980949,1021652,771159,871582,224236,73279,420674,948459,372494,769639,232619,879731,26968,700102,1034792,721620,283561,20792,916359,845990,579579,810473,184481,1002329,48030,987165,560008,892687,719014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]