SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 234438 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 234438 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112783,806379,268795,111853,10750,65875,628813,429967,222262,510659,1012169,392581,211145,977767,400897,167733,159096,230551,75777,308066,3158,796007,202728,819541,553571,438548,537795,219154,687573,1037891,31881,370056,418424,539913,950360,107128,229860,82309,559634,696977,132907,21130,936753,929786,245401,147158,473934,1023083,1030527,891809,63928,218546,258589,733648,493733,832347,993474,456291,36405,378717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 234438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 234438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]