SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314625 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314625 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262134,1007227,962223,934110,544131,351576,288503,164906,5589,751462,3856,948891,449742,468246,117077,483005,629765,163759,304744,752308,196468,742119,126972,111971,483984,205537,1024378,1019213,539735,545832,59285,668451,475407,196085,644765,690791,864150,835367,819477,655589,442535,415700,1022663,730375,433483,500291,478598,796091,596089,41845,337184,166092,143051,643253,660369,925664,844048,512363,192250,726138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314625 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314625 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]