SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 942011 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 942011 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (908710,254298,964427,765597,362071,161914,112975,805929,192308,842964,913197,1018986,882378,415036,1021553,145078,447495,832975,913517,916372,963929,1045689,864834,699529,926885,103219,812943,120351,603838,541799,470145,379205,860943,599752,774280,758218,88190,624017,559842,341541,131298,533540,1029536,545444,271069,701171,988070,307382,448807,20135,579556,14406,510161,621281,465008,843444,441648,104886,920526,592277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 942011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 942011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003054s ]