SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527951 LIMIT 1 [ RunTime:0.001693s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527951 [ RunTime:0.003311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (978796,1021715,48977,816607,800514,208406,111838,168928,1027339,186238,598931,357485,623313,510988,347265,295678,3632,86861,376872,467442,63813,107435,779705,437133,78272,202710,335791,185318,303410,680717,715618,743565,658918,797074,629670,208715,688924,618639,659667,1010093,412483,698802,48416,724362,385338,8307,517311,899630,330410,592947,40577,266053,806093,329719,570225,556080,1005450,894122,140096,173108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001235s ]