SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109971 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109971 [ RunTime:0.001456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321276,176185,475392,410615,92074,425579,686782,525159,947544,922262,452587,803962,197569,791941,54907,479277,882073,840042,816385,886840,1009396,136449,563261,368973,332796,520454,476327,262427,120527,1011780,815235,766687,216935,832127,204122,890339,6173,969762,860896,959647,159249,981408,347505,160090,33874,237035,151580,629841,340623,843217,733744,298341,555904,765765,580987,757951,733147,672323,822692,506091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001592s ]