SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545681 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545681 [ RunTime:0.002256s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21310,987510,20766,591601,47600,302592,931865,667086,98440,776176,187135,729453,946929,287274,250894,787269,636029,639980,879361,429194,382684,656854,29808,446581,947833,893456,857003,117114,720134,210772,389206,625801,370029,578599,569977,360789,512591,726394,626209,712783,683223,467735,103604,941348,432401,775162,102676,243503,724359,742750,1022516,266591,727991,772074,711613,856453,893365,879259,136911,682485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]