SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030086 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030086 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (462170,471659,843500,665859,326615,816892,641878,52096,178336,491540,684588,840614,634637,1005641,517443,442160,1046575,916340,23197,660969,232510,897248,263800,535708,531407,387913,822951,166363,147511,571817,217745,465770,925810,937818,477601,857464,645756,567109,553570,78024,428138,978851,549560,998013,645943,784328,272111,818544,524690,480794,347641,351053,587290,388612,373693,111340,563899,1006306,385041,19177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030086 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030086 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]