SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425431 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425431 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110502,43533,313637,936981,621159,1030821,977856,273030,230755,180415,900524,643011,234040,299788,607607,326585,922524,487170,741982,978166,304666,168086,520424,1023315,344996,687209,975342,954332,985174,556918,125202,87991,914278,8835,907763,420503,444173,909119,327840,433579,243963,473585,871993,320767,982370,699737,163597,252406,688251,290186,133470,456665,286528,796046,393987,284159,292798,593584,390869,602677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]