SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291514 LIMIT 1 [ RunTime:0.001909s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291514 [ RunTime:0.005012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (84444,280871,586411,202475,150413,763916,389804,975458,151211,1004299,435182,1030564,217942,575405,708156,548359,240112,803451,804985,725340,65805,620173,428465,690484,912679,545886,544842,322763,929304,666194,643432,176773,42473,59192,828681,835577,465774,224664,512555,282453,893341,979246,140834,204760,609366,652513,235196,477850,360099,316847,879043,570086,396356,378553,311283,962513,827274,90146,733979,950407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]