SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034084 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034084 [ RunTime:0.002925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109539,232390,773249,414687,94328,921172,936440,187977,198630,632362,343695,244407,149111,928776,933522,595544,231905,547681,384594,1034927,1019581,557865,896672,543806,8906,131400,669497,375489,592113,250125,1038006,328164,570994,36586,1003120,120474,570574,495400,25896,187593,846789,74423,857643,654903,935212,742718,931991,385448,406438,437293,475458,1033951,830022,931597,695792,628153,756548,103368,219719,757375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]