SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005664s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538705 LIMIT 1 [ RunTime:0.001518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538705 [ RunTime:0.005009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102511,406253,663517,71766,992498,950115,871375,751447,2900,239591,418823,261781,341325,399308,435608,263275,55308,892598,446422,314643,598606,670397,374283,940478,876816,410885,118754,226227,602736,944345,635765,542014,478407,138109,571813,1047134,385189,389907,564243,847448,557263,701577,767709,788522,795224,220600,35114,739031,84839,826294,77046,66010,1011491,673224,17391,652324,604072,417863,519177,892984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538705 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538705 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]