SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489092 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489092 [ RunTime:0.002037s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714318,620281,14164,102981,865256,170493,831471,184252,420328,300,1008772,872523,587694,38882,718616,440645,896673,769153,46260,849915,628800,403722,404067,898146,913914,916262,522365,379134,205207,581822,18378,626412,140806,955276,77714,508881,638896,114453,59034,118285,318046,305794,99230,75893,85899,112008,130422,408963,682420,979134,454384,859983,459614,555037,660600,437960,941980,372592,801878,691894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]