SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310425 LIMIT 1 [ RunTime:0.001397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310425 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618583,992776,282089,926666,75620,586107,911672,420440,120388,518623,665877,52797,950824,233145,404987,345940,1030465,162606,78991,510750,305794,898992,700777,805816,414866,154144,460292,615067,242561,448008,739661,3307,929624,272386,168842,346830,463387,10172,348988,684252,929743,591275,1030313,711426,866414,616610,420924,638435,694994,159629,84679,493953,638080,881500,147178,39224,425797,422272,594814,939455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310425 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310425 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]