SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029736 LIMIT 1 [ RunTime:0.001478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029736 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525050,951109,29535,696210,656235,129907,1028406,876188,414580,105708,444491,59386,172278,163223,436225,1039861,957974,909160,651441,505299,261903,431665,172976,564924,47932,525203,484082,762297,747104,8922,162234,912380,826460,370784,563131,159197,601673,707735,342692,343172,862580,834478,108626,891278,984130,499857,350724,597679,448717,236066,539669,608511,710168,740170,116252,315108,790938,443285,825165,332956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029736 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029736 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]